private static String zifDir = "e:/zipfile/";
    public ZipOutputStream zipFile(List<ZipFileItem> items) throws Exception{
        String filePath = zifDir + UUID.randomUUID().toString()+".zip";
        FileOutputStream fileOutputStream = new FileOutputStream(filePath);
        ZipOutputStream zip = new ZipOutputStream(fileOutputStream);
        int count = -1;
        byte buff[] = new byte[1024];
        for (ZipFileItem item : items) {
            try {
                ZipEntry entry = new ZipEntry(item.getName());
                zip.putNextEntry(entry);
                while((count = item.getIs().read(buff)) != -1){
                    zip.write(buff,0,count);
                }
                item.getIs().close();
            }catch (Exception e){
                e.printStackTrace();
            }
        }
        return zip;
    }


    ALTER TABLE test ADD camera_wifi VARCHAR(255);
ALTER TABLE test ADD camera_wifi_password VARCHAR(255);
ALTER TABLE test ADD bluetooth_code VARCHAR(255);
ALTER TABLE test ADD pad_bluetooth_code VARCHAR(255); 
ALTER TABLE test ADD pad_os_name VARCHAR(255);

    private static class ZipFileItem{
        private String name;
        private InputStream is;

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }

        public InputStream getIs() {
            return is;
        }

        public void setIs(InputStream is) {
            this.is = is;
        }
    }